Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 34642 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.3 MiB |
| Average record size in memory | 160.0 B |
Variable types
| Numeric | 19 |
|---|---|
| DateTime | 1 |
AC 17 is highly correlated with AC 18 | High correlation |
AC 18 is highly correlated with AC 17 | High correlation |
df_index is highly correlated with AC 1 and 3 other fields | High correlation |
AC 1 is highly correlated with df_index | High correlation |
AC 2 is highly correlated with df_index and 1 other fields | High correlation |
AC 3 is highly correlated with df_index | High correlation |
AC 4 is highly correlated with AC 2 | High correlation |
AC 11 is highly correlated with AC 12 and 1 other fields | High correlation |
AC 12 is highly correlated with AC 11 | High correlation |
AC 14 is highly correlated with AC 11 | High correlation |
AC 17 is highly correlated with AC 18 | High correlation |
AC 18 is highly correlated with df_index and 1 other fields | High correlation |
df_index has unique values | Unique |
Date & Time has unique values | Unique |
AC 1 has 11570 (33.4%) zeros | Zeros |
AC 2 has 3613 (10.4%) zeros | Zeros |
AC 3 has 3809 (11.0%) zeros | Zeros |
AC 4 has 7581 (21.9%) zeros | Zeros |
AC 5 has 2588 (7.5%) zeros | Zeros |
AC 6 has 5455 (15.7%) zeros | Zeros |
AC 7 has 3355 (9.7%) zeros | Zeros |
AC 8 has 5331 (15.4%) zeros | Zeros |
AC 9 has 2367 (6.8%) zeros | Zeros |
AC 10 has 1903 (5.5%) zeros | Zeros |
AC 11 has 5270 (15.2%) zeros | Zeros |
AC 12 has 3163 (9.1%) zeros | Zeros |
AC 13 has 1852 (5.3%) zeros | Zeros |
AC 14 has 1423 (4.1%) zeros | Zeros |
AC 15 has 2994 (8.6%) zeros | Zeros |
AC 16 has 3661 (10.6%) zeros | Zeros |
AC 17 has 583 (1.7%) zeros | Zeros |
AC 18 has 837 (2.4%) zeros | Zeros |
Reproduction
| Analysis started | 2021-12-22 19:55:28.558002 |
|---|---|
| Analysis finished | 2021-12-22 19:56:38.477648 |
| Duration | 1 minute and 9.92 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 34642 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47474.87836 |
| Minimum | 0 |
|---|---|
| Maximum | 87839 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3536.1 |
| Q1 | 17874.5 |
| median | 51180 |
| Q3 | 70077.5 |
| 95-th percentile | 84296.9 |
| Maximum | 87839 |
| Range | 87839 |
| Interquartile range (IQR) | 52203 |
Descriptive statistics
| Standard deviation | 26576.43508 |
|---|---|
| Coefficient of variation (CV) | 0.5597999615 |
| Kurtosis | -1.148025165 |
| Mean | 47474.87836 |
| Median Absolute Deviation (MAD) | 19907 |
| Skewness | -0.3319867658 |
| Sum | 1644624736 |
| Variance | 706306901.4 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 41761 | 1 | < 0.1% |
| 70336 | 1 | < 0.1% |
| 72162 | 1 | < 0.1% |
| 72502 | 1 | < 0.1% |
| 66904 | 1 | < 0.1% |
| 2868 | 1 | < 0.1% |
| 15154 | 1 | < 0.1% |
| 74545 | 1 | < 0.1% |
| 11056 | 1 | < 0.1% |
| Other values (34632) | 34632 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 2 | 1 | |
| 4 | 1 | |
| 6 | 1 | |
| 8 | 1 | |
| 10 | 1 | |
| 12 | 1 | |
| 14 | 1 | |
| 18 | 1 | |
| 20 | 1 |
| Value | Count | Frequency (%) |
| 87839 | 1 | |
| 87837 | 1 | |
| 87835 | 1 | |
| 87833 | 1 | |
| 87831 | 1 | |
| 87829 | 1 | |
| 87827 | 1 | |
| 87825 | 1 | |
| 87823 | 1 | |
| 87821 | 1 |
| Distinct | 34642 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 270.8 KiB |
| Minimum | 2019-08-01 00:00:00 |
|---|---|
| Maximum | 2019-09-30 23:59:00 |
| Distinct | 23054 |
|---|---|
| Distinct (%) | 66.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.394089398 |
| Minimum | 0 |
|---|---|
| Maximum | 11.19478906 |
| Zeros | 11570 |
| Zeros (%) | 33.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2.081296143 |
| Q3 | 3.767716064 |
| 95-th percentile | 6.897859058 |
| Maximum | 11.19478906 |
| Range | 11.19478906 |
| Interquartile range (IQR) | 3.767716064 |
Descriptive statistics
| Standard deviation | 2.309156098 |
|---|---|
| Coefficient of variation (CV) | 0.9645237559 |
| Kurtosis | -0.03893428644 |
| Mean | 2.394089398 |
| Median Absolute Deviation (MAD) | 2.081296143 |
| Skewness | 0.7917478274 |
| Sum | 82936.04491 |
| Variance | 5.332201884 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 11570 | |
| 3.019473633 | 2 | < 0.1% |
| 1.871588867 | 2 | < 0.1% |
| 7.455938965 | 2 | < 0.1% |
| 4.186901855 | 2 | < 0.1% |
| 4.132759766 | 2 | < 0.1% |
| 2.908268066 | 2 | < 0.1% |
| 3.164794434 | 2 | < 0.1% |
| 6.021251953 | 2 | < 0.1% |
| 4.524077637 | 2 | < 0.1% |
| Other values (23044) | 23054 |
| Value | Count | Frequency (%) |
| 0 | 11570 | |
| 0.0616844368 | 1 | < 0.1% |
| 0.07653198242 | 1 | < 0.1% |
| 0.1067472687 | 1 | < 0.1% |
| 0.11033638 | 1 | < 0.1% |
| 0.1174385757 | 1 | < 0.1% |
| 0.122889595 | 1 | < 0.1% |
| 0.1323277283 | 1 | < 0.1% |
| 0.1344907684 | 1 | < 0.1% |
| 0.1487676697 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11.19478906 | 1 | |
| 11.02978223 | 1 | |
| 11.02866602 | 1 | |
| 11.0239375 | 1 | |
| 11.01845313 | 1 | |
| 11.00308691 | 1 | |
| 10.99454395 | 1 | |
| 10.96971777 | 1 | |
| 10.91394434 | 1 | |
| 10.79010742 | 1 |
| Distinct | 31006 |
|---|---|
| Distinct (%) | 89.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.872065429 |
| Minimum | 0 |
|---|---|
| Maximum | 11.14714063 |
| Zeros | 3613 |
| Zeros (%) | 10.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2.272895203 |
| median | 3.738743286 |
| Q3 | 5.334570435 |
| 95-th percentile | 8.27211416 |
| Maximum | 11.14714063 |
| Range | 11.14714063 |
| Interquartile range (IQR) | 3.061675232 |
Descriptive statistics
| Standard deviation | 2.360155204 |
|---|---|
| Coefficient of variation (CV) | 0.6095339159 |
| Kurtosis | -0.2211130572 |
| Mean | 3.872065429 |
| Median Absolute Deviation (MAD) | 1.524687866 |
| Skewness | 0.3305838235 |
| Sum | 134136.0906 |
| Variance | 5.570332585 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3613 | 10.4% |
| 2.872945557 | 2 | < 0.1% |
| 2.724344482 | 2 | < 0.1% |
| 4.035023437 | 2 | < 0.1% |
| 4.527638672 | 2 | < 0.1% |
| 4.438061523 | 2 | < 0.1% |
| 8.185853027 | 2 | < 0.1% |
| 3.283741943 | 2 | < 0.1% |
| 9.111301758 | 2 | < 0.1% |
| 3.12289502 | 2 | < 0.1% |
| Other values (30996) | 31011 |
| Value | Count | Frequency (%) |
| 0 | 3613 | |
| 0.04285964203 | 1 | < 0.1% |
| 0.04794764328 | 1 | < 0.1% |
| 0.06230761337 | 1 | < 0.1% |
| 0.0639708786 | 1 | < 0.1% |
| 0.06400770569 | 1 | < 0.1% |
| 0.0640224762 | 1 | < 0.1% |
| 0.06408698273 | 1 | < 0.1% |
| 0.06414063263 | 1 | < 0.1% |
| 0.06518546295 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11.14714063 | 1 | |
| 11.1288418 | 1 | |
| 11.11222559 | 1 | |
| 11.09907031 | 1 | |
| 11.07564746 | 1 | |
| 11.0496377 | 1 | |
| 11.03469531 | 1 | |
| 11.0314541 | 1 | |
| 11.01084863 | 1 | |
| 11.00639453 | 1 |
| Distinct | 30800 |
|---|---|
| Distinct (%) | 88.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.504698491 |
| Minimum | 0 |
|---|---|
| Maximum | 8.43090918 |
| Zeros | 3809 |
| Zeros (%) | 11.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.663071533 |
| median | 2.417197144 |
| Q3 | 3.351790955 |
| 95-th percentile | 5.04409082 |
| Maximum | 8.43090918 |
| Range | 8.43090918 |
| Interquartile range (IQR) | 1.688719421 |
Descriptive statistics
| Standard deviation | 1.452713419 |
|---|---|
| Coefficient of variation (CV) | 0.5799953265 |
| Kurtosis | 0.3613781141 |
| Mean | 2.504698491 |
| Median Absolute Deviation (MAD) | 0.8353283081 |
| Skewness | 0.3422027003 |
| Sum | 86767.76513 |
| Variance | 2.110376278 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3809 | 11.0% |
| 3.847365479 | 2 | < 0.1% |
| 1.365873291 | 2 | < 0.1% |
| 1.880836792 | 2 | < 0.1% |
| 2.587766113 | 2 | < 0.1% |
| 2.910477783 | 2 | < 0.1% |
| 1.578948364 | 2 | < 0.1% |
| 2.36289209 | 2 | < 0.1% |
| 2.159558105 | 2 | < 0.1% |
| 2.099674316 | 2 | < 0.1% |
| Other values (30790) | 30815 |
| Value | Count | Frequency (%) |
| 0 | 3809 | |
| 0.0742535553 | 1 | < 0.1% |
| 0.07536616516 | 1 | < 0.1% |
| 0.07730276489 | 1 | < 0.1% |
| 0.0794705658 | 1 | < 0.1% |
| 0.08052623749 | 1 | < 0.1% |
| 0.08061908722 | 1 | < 0.1% |
| 0.08279086304 | 1 | < 0.1% |
| 0.09293652344 | 1 | < 0.1% |
| 0.09821147156 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 8.43090918 | 1 | |
| 8.411494141 | 1 | |
| 8.333665039 | 1 | |
| 8.330175781 | 1 | |
| 8.272776367 | 1 | |
| 8.262228516 | 1 | |
| 8.238150391 | 1 | |
| 8.235042969 | 1 | |
| 8.225069336 | 1 | |
| 8.203635742 | 1 |
| Distinct | 27035 |
|---|---|
| Distinct (%) | 78.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.313283362 |
| Minimum | 0 |
|---|---|
| Maximum | 9.849143555 |
| Zeros | 7581 |
| Zeros (%) | 21.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.279719116 |
| median | 2.255592773 |
| Q3 | 3.313595459 |
| 95-th percentile | 5.370586548 |
| Maximum | 9.849143555 |
| Range | 9.849143555 |
| Interquartile range (IQR) | 2.033876343 |
Descriptive statistics
| Standard deviation | 1.705811038 |
|---|---|
| Coefficient of variation (CV) | 0.737398222 |
| Kurtosis | 0.009144763889 |
| Mean | 2.313283362 |
| Median Absolute Deviation (MAD) | 1.019396179 |
| Skewness | 0.4474233639 |
| Sum | 80136.76223 |
| Variance | 2.909791298 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 7581 | 21.9% |
| 2.34465625 | 2 | < 0.1% |
| 3.024609375 | 2 | < 0.1% |
| 2.34965625 | 2 | < 0.1% |
| 4.424061035 | 2 | < 0.1% |
| 2.519458252 | 2 | < 0.1% |
| 2.785541016 | 2 | < 0.1% |
| 2.267689453 | 2 | < 0.1% |
| 2.712394775 | 2 | < 0.1% |
| 4.321238281 | 2 | < 0.1% |
| Other values (27025) | 27043 |
| Value | Count | Frequency (%) |
| 0 | 7581 | |
| 1.423256192 × 10-5 | 1 | < 0.1% |
| 0.0004910462797 | 1 | < 0.1% |
| 0.001534701347 | 1 | < 0.1% |
| 0.002670838594 | 1 | < 0.1% |
| 0.002782246113 | 1 | < 0.1% |
| 0.003369998693 | 1 | < 0.1% |
| 0.003763606787 | 1 | < 0.1% |
| 0.004028562069 | 1 | < 0.1% |
| 0.01386952305 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.849143555 | 1 | |
| 9.728601562 | 1 | |
| 9.631849609 | 1 | |
| 9.600250977 | 1 | |
| 9.549112305 | 1 | |
| 9.538166016 | 1 | |
| 9.518945312 | 1 | |
| 9.518727539 | 1 | |
| 9.469880859 | 1 | |
| 9.36712793 | 1 |
| Distinct | 32023 |
|---|---|
| Distinct (%) | 92.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.466444486 |
| Minimum | 0 |
|---|---|
| Maximum | 5.495358398 |
| Zeros | 2588 |
| Zeros (%) | 7.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.00832634 |
| median | 1.408947998 |
| Q3 | 1.903033508 |
| 95-th percentile | 2.756116174 |
| Maximum | 5.495358398 |
| Range | 5.495358398 |
| Interquartile range (IQR) | 0.8947071686 |
Descriptive statistics
| Standard deviation | 0.7485150551 |
|---|---|
| Coefficient of variation (CV) | 0.510428497 |
| Kurtosis | 0.7236269949 |
| Mean | 1.466444486 |
| Median Absolute Deviation (MAD) | 0.4394423523 |
| Skewness | 0.3511872826 |
| Sum | 50800.5699 |
| Variance | 0.5602747877 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2588 | 7.5% |
| 2.03893042 | 2 | < 0.1% |
| 1.979017456 | 2 | < 0.1% |
| 1.50166687 | 2 | < 0.1% |
| 1.77949707 | 2 | < 0.1% |
| 1.261974976 | 2 | < 0.1% |
| 1.239431274 | 2 | < 0.1% |
| 2.493119141 | 2 | < 0.1% |
| 1.071717529 | 2 | < 0.1% |
| 2.062584473 | 2 | < 0.1% |
| Other values (32013) | 32036 |
| Value | Count | Frequency (%) |
| 0 | 2588 | |
| 0.07341772461 | 1 | < 0.1% |
| 0.07348339081 | 1 | < 0.1% |
| 0.07452122498 | 1 | < 0.1% |
| 0.07495846558 | 1 | < 0.1% |
| 0.07612695312 | 1 | < 0.1% |
| 0.08035838318 | 1 | < 0.1% |
| 0.09692716217 | 1 | < 0.1% |
| 0.1132143555 | 1 | < 0.1% |
| 0.1216780243 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5.495358398 | 1 | |
| 5.20192334 | 1 | |
| 5.043223633 | 1 | |
| 5.041179199 | 1 | |
| 4.906216797 | 1 | |
| 4.892197754 | 1 | |
| 4.884592285 | 1 | |
| 4.87679248 | 1 | |
| 4.876376465 | 1 | |
| 4.874012695 | 1 |
| Distinct | 29151 |
|---|---|
| Distinct (%) | 84.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.709061098 |
| Minimum | 0 |
|---|---|
| Maximum | 9.929291016 |
| Zeros | 5455 |
| Zeros (%) | 15.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.877316162 |
| median | 2.819161865 |
| Q3 | 3.742867737 |
| 95-th percentile | 5.195097388 |
| Maximum | 9.929291016 |
| Range | 9.929291016 |
| Interquartile range (IQR) | 1.865551575 |
Descriptive statistics
| Standard deviation | 1.590249042 |
|---|---|
| Coefficient of variation (CV) | 0.5870111396 |
| Kurtosis | -0.2300756941 |
| Mean | 2.709061098 |
| Median Absolute Deviation (MAD) | 0.9327965088 |
| Skewness | -0.1068010393 |
| Sum | 93847.29455 |
| Variance | 2.528892016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5455 | 15.7% |
| 5.107904297 | 2 | < 0.1% |
| 3.849658447 | 2 | < 0.1% |
| 1.767871582 | 2 | < 0.1% |
| 5.927287598 | 2 | < 0.1% |
| 4.623115723 | 2 | < 0.1% |
| 2.63522876 | 2 | < 0.1% |
| 3.60592334 | 2 | < 0.1% |
| 3.445003662 | 2 | < 0.1% |
| 3.669658936 | 2 | < 0.1% |
| Other values (29141) | 29169 |
| Value | Count | Frequency (%) |
| 0 | 5455 | |
| 0.06465927887 | 1 | < 0.1% |
| 0.09148364258 | 1 | < 0.1% |
| 0.09236633301 | 1 | < 0.1% |
| 0.09339237213 | 1 | < 0.1% |
| 0.09700898743 | 1 | < 0.1% |
| 0.09711601257 | 1 | < 0.1% |
| 0.0983099823 | 1 | < 0.1% |
| 0.09832727814 | 1 | < 0.1% |
| 0.100603981 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.929291016 | 1 | |
| 9.666423828 | 1 | |
| 9.227158203 | 1 | |
| 8.944285156 | 1 | |
| 8.818060547 | 1 | |
| 8.784804687 | 1 | |
| 8.595863281 | 1 | |
| 8.365535156 | 1 | |
| 8.330058594 | 1 | |
| 8.324936523 | 1 |
| Distinct | 31255 |
|---|---|
| Distinct (%) | 90.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.945135605 |
| Minimum | 0 |
|---|---|
| Maximum | 9.356776367 |
| Zeros | 3355 |
| Zeros (%) | 9.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2.161930786 |
| median | 2.976191284 |
| Q3 | 3.852767273 |
| 95-th percentile | 5.347440649 |
| Maximum | 9.356776367 |
| Range | 9.356776367 |
| Interquartile range (IQR) | 1.690836487 |
Descriptive statistics
| Standard deviation | 1.487934048 |
|---|---|
| Coefficient of variation (CV) | 0.5052175001 |
| Kurtosis | 0.4155042966 |
| Mean | 2.945135605 |
| Median Absolute Deviation (MAD) | 0.8436320801 |
| Skewness | -0.04822787553 |
| Sum | 102025.3876 |
| Variance | 2.213947731 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3355 | 9.7% |
| 3.14246582 | 2 | < 0.1% |
| 2.527106445 | 2 | < 0.1% |
| 4.276289551 | 2 | < 0.1% |
| 4.237095703 | 2 | < 0.1% |
| 3.240780273 | 2 | < 0.1% |
| 3.496192871 | 2 | < 0.1% |
| 3.043163086 | 2 | < 0.1% |
| 2.649957031 | 2 | < 0.1% |
| 2.815222656 | 2 | < 0.1% |
| Other values (31245) | 31269 |
| Value | Count | Frequency (%) |
| 0 | 3355 | |
| 0.05282098389 | 1 | < 0.1% |
| 0.05658594131 | 1 | < 0.1% |
| 0.05895381165 | 1 | < 0.1% |
| 0.06176008987 | 1 | < 0.1% |
| 0.06493132782 | 1 | < 0.1% |
| 0.06606751251 | 1 | < 0.1% |
| 0.06822737122 | 1 | < 0.1% |
| 0.06858148193 | 1 | < 0.1% |
| 0.0746751709 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.356776367 | 1 | |
| 9.259009766 | 1 | |
| 9.251232422 | 1 | |
| 9.202111328 | 1 | |
| 9.200707031 | 1 | |
| 9.153392578 | 1 | |
| 9.146301758 | 1 | |
| 9.112842773 | 1 | |
| 9.107796875 | 1 | |
| 9.07315332 | 1 |
| Distinct | 29269 |
|---|---|
| Distinct (%) | 84.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.568989438 |
| Minimum | 0 |
|---|---|
| Maximum | 9.331505859 |
| Zeros | 5331 |
| Zeros (%) | 15.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.766606171 |
| median | 2.62213562 |
| Q3 | 3.538364075 |
| 95-th percentile | 5.037801733 |
| Maximum | 9.331505859 |
| Range | 9.331505859 |
| Interquartile range (IQR) | 1.771757904 |
Descriptive statistics
| Standard deviation | 1.531968043 |
|---|---|
| Coefficient of variation (CV) | 0.5963310009 |
| Kurtosis | -0.09593831258 |
| Mean | 2.568989438 |
| Median Absolute Deviation (MAD) | 0.885206543 |
| Skewness | 0.008589821761 |
| Sum | 88994.93213 |
| Variance | 2.346926085 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5331 | 15.4% |
| 3.324664551 | 2 | < 0.1% |
| 2.706187256 | 2 | < 0.1% |
| 3.133732178 | 2 | < 0.1% |
| 2.652265381 | 2 | < 0.1% |
| 2.109123779 | 2 | < 0.1% |
| 2.450452637 | 2 | < 0.1% |
| 3.139876953 | 2 | < 0.1% |
| 2.562466309 | 2 | < 0.1% |
| 3.045667969 | 2 | < 0.1% |
| Other values (29259) | 29293 |
| Value | Count | Frequency (%) |
| 0 | 5331 | |
| 0.01094765377 | 1 | < 0.1% |
| 0.04681337357 | 1 | < 0.1% |
| 0.05472441101 | 1 | < 0.1% |
| 0.06058576202 | 1 | < 0.1% |
| 0.06112965775 | 1 | < 0.1% |
| 0.06130023956 | 1 | < 0.1% |
| 0.06155838394 | 1 | < 0.1% |
| 0.06180289078 | 1 | < 0.1% |
| 0.06196854401 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.331505859 | 1 | |
| 9.224646484 | 1 | |
| 9.12290332 | 1 | |
| 9.043263672 | 1 | |
| 9.030961914 | 1 | |
| 9.0003125 | 1 | |
| 8.881724609 | 1 | |
| 8.76128418 | 1 | |
| 8.636970703 | 1 | |
| 8.613015625 | 1 |
| Distinct | 32241 |
|---|---|
| Distinct (%) | 93.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.149919277 |
| Minimum | 0 |
|---|---|
| Maximum | 10.02674707 |
| Zeros | 2367 |
| Zeros (%) | 6.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2.273552063 |
| median | 3.046701538 |
| Q3 | 4.046423828 |
| 95-th percentile | 5.824332959 |
| Maximum | 10.02674707 |
| Range | 10.02674707 |
| Interquartile range (IQR) | 1.772871765 |
Descriptive statistics
| Standard deviation | 1.534837638 |
|---|---|
| Coefficient of variation (CV) | 0.4872625304 |
| Kurtosis | 0.8566130427 |
| Mean | 3.149919277 |
| Median Absolute Deviation (MAD) | 0.8699578857 |
| Skewness | 0.2796879564 |
| Sum | 109119.5036 |
| Variance | 2.355726575 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2367 | 6.8% |
| 2.178085938 | 2 | < 0.1% |
| 3.086960693 | 2 | < 0.1% |
| 2.606552002 | 2 | < 0.1% |
| 3.055231201 | 2 | < 0.1% |
| 3.597266357 | 2 | < 0.1% |
| 4.305642578 | 2 | < 0.1% |
| 4.764799805 | 2 | < 0.1% |
| 3.708388428 | 2 | < 0.1% |
| 3.05663208 | 2 | < 0.1% |
| Other values (32231) | 32257 |
| Value | Count | Frequency (%) |
| 0 | 2367 | |
| 0.08138726044 | 1 | < 0.1% |
| 0.08161660767 | 1 | < 0.1% |
| 0.0887253418 | 1 | < 0.1% |
| 0.08977192688 | 1 | < 0.1% |
| 0.1052763138 | 1 | < 0.1% |
| 0.107641304 | 1 | < 0.1% |
| 0.1096568604 | 1 | < 0.1% |
| 0.1099549484 | 1 | < 0.1% |
| 0.1100972519 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10.02674707 | 1 | |
| 9.798385742 | 1 | |
| 9.749407227 | 1 | |
| 9.667248047 | 1 | |
| 9.607086914 | 1 | |
| 9.595224609 | 1 | |
| 9.56228125 | 1 | |
| 9.537615234 | 1 | |
| 9.524496094 | 1 | |
| 9.523412109 | 1 |
| Distinct | 32711 |
|---|---|
| Distinct (%) | 94.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.539393139 |
| Minimum | 0 |
|---|---|
| Maximum | 4.625029785 |
| Zeros | 1903 |
| Zeros (%) | 5.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.106887299 |
| median | 1.500257202 |
| Q3 | 1.97783606 |
| 95-th percentile | 2.742939941 |
| Maximum | 4.625029785 |
| Range | 4.625029785 |
| Interquartile range (IQR) | 0.870948761 |
Descriptive statistics
| Standard deviation | 0.7003723441 |
|---|---|
| Coefficient of variation (CV) | 0.4549665229 |
| Kurtosis | 0.4261369435 |
| Mean | 1.539393139 |
| Median Absolute Deviation (MAD) | 0.4287334595 |
| Skewness | 0.1226602453 |
| Sum | 53327.65714 |
| Variance | 0.4905214204 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1903 | 5.5% |
| 1.829689819 | 2 | < 0.1% |
| 2.115071289 | 2 | < 0.1% |
| 1.197075195 | 2 | < 0.1% |
| 0.6590256348 | 2 | < 0.1% |
| 1.560997437 | 2 | < 0.1% |
| 1.264098267 | 2 | < 0.1% |
| 1.040553223 | 2 | < 0.1% |
| 1.98887439 | 2 | < 0.1% |
| 0.9309008179 | 2 | < 0.1% |
| Other values (32701) | 32721 |
| Value | Count | Frequency (%) |
| 0 | 1903 | |
| 0.07110451508 | 1 | < 0.1% |
| 0.07147119904 | 1 | < 0.1% |
| 0.07976487732 | 1 | < 0.1% |
| 0.08359114838 | 1 | < 0.1% |
| 0.100279953 | 1 | < 0.1% |
| 0.1003293457 | 1 | < 0.1% |
| 0.1011818008 | 1 | < 0.1% |
| 0.1034925995 | 1 | < 0.1% |
| 0.1034997025 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4.625029785 | 1 | |
| 4.561019531 | 1 | |
| 4.498272461 | 1 | |
| 4.429328125 | 1 | |
| 4.428435547 | 1 | |
| 4.3871875 | 1 | |
| 4.355806152 | 1 | |
| 4.321361328 | 1 | |
| 4.259918457 | 1 | |
| 4.248070801 | 1 |
| Distinct | 29342 |
|---|---|
| Distinct (%) | 84.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.486161853 |
| Minimum | 0 |
|---|---|
| Maximum | 10.36315137 |
| Zeros | 5270 |
| Zeros (%) | 15.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.640117249 |
| median | 2.409043335 |
| Q3 | 3.36275293 |
| 95-th percentile | 5.170304077 |
| Maximum | 10.36315137 |
| Range | 10.36315137 |
| Interquartile range (IQR) | 1.722635681 |
Descriptive statistics
| Standard deviation | 1.588902335 |
|---|---|
| Coefficient of variation (CV) | 0.6390985097 |
| Kurtosis | 1.075884584 |
| Mean | 2.486161853 |
| Median Absolute Deviation (MAD) | 0.856703125 |
| Skewness | 0.5189782705 |
| Sum | 86125.6189 |
| Variance | 2.52461063 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5270 | 15.2% |
| 3.004993408 | 2 | < 0.1% |
| 4.154209473 | 2 | < 0.1% |
| 3.315104492 | 2 | < 0.1% |
| 2.410487549 | 2 | < 0.1% |
| 1.059351563 | 2 | < 0.1% |
| 3.834279785 | 2 | < 0.1% |
| 2.321346924 | 2 | < 0.1% |
| 1.903718018 | 2 | < 0.1% |
| 4.957069336 | 2 | < 0.1% |
| Other values (29332) | 29354 |
| Value | Count | Frequency (%) |
| 0 | 5270 | |
| 0.07264399719 | 1 | < 0.1% |
| 0.07793022919 | 1 | < 0.1% |
| 0.09986977386 | 1 | < 0.1% |
| 0.1012279358 | 1 | < 0.1% |
| 0.1023413467 | 1 | < 0.1% |
| 0.1035502548 | 1 | < 0.1% |
| 0.1037963257 | 1 | < 0.1% |
| 0.1051286697 | 1 | < 0.1% |
| 0.1053280411 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10.36315137 | 1 | |
| 10.34442676 | 1 | |
| 10.09486426 | 1 | |
| 9.982568359 | 1 | |
| 9.886742187 | 1 | |
| 9.877746094 | 1 | |
| 9.876814453 | 1 | |
| 9.870907227 | 1 | |
| 9.867012695 | 1 | |
| 9.835919922 | 1 |
| Distinct | 31444 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.815970359 |
| Minimum | 0 |
|---|---|
| Maximum | 9.887305664 |
| Zeros | 3163 |
| Zeros (%) | 9.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2.066214294 |
| median | 2.824785889 |
| Q3 | 3.660598999 |
| 95-th percentile | 5.017686597 |
| Maximum | 9.887305664 |
| Range | 9.887305664 |
| Interquartile range (IQR) | 1.594384705 |
Descriptive statistics
| Standard deviation | 1.402621897 |
|---|---|
| Coefficient of variation (CV) | 0.4980954053 |
| Kurtosis | 0.8118488801 |
| Mean | 2.815970359 |
| Median Absolute Deviation (MAD) | 0.7939100342 |
| Skewness | 0.04718841721 |
| Sum | 97550.84518 |
| Variance | 1.967348187 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3163 | 9.1% |
| 2.786959473 | 2 | < 0.1% |
| 2.832355225 | 2 | < 0.1% |
| 3.165344482 | 2 | < 0.1% |
| 3.706915771 | 2 | < 0.1% |
| 2.601605957 | 2 | < 0.1% |
| 3.920286865 | 2 | < 0.1% |
| 2.696984131 | 2 | < 0.1% |
| 4.693541992 | 2 | < 0.1% |
| 2.814131592 | 2 | < 0.1% |
| Other values (31434) | 31461 |
| Value | Count | Frequency (%) |
| 0 | 3163 | |
| 0.04597567749 | 1 | < 0.1% |
| 0.06100495911 | 1 | < 0.1% |
| 0.06218890381 | 1 | < 0.1% |
| 0.06372197723 | 1 | < 0.1% |
| 0.06406093597 | 1 | < 0.1% |
| 0.06573043823 | 1 | < 0.1% |
| 0.06598792267 | 1 | < 0.1% |
| 0.06802828217 | 1 | < 0.1% |
| 0.07106945038 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.887305664 | 1 | |
| 9.708526367 | 1 | |
| 9.660108398 | 1 | |
| 9.632356445 | 1 | |
| 9.576805664 | 1 | |
| 9.573359375 | 1 | |
| 9.567575195 | 1 | |
| 9.561782227 | 1 | |
| 9.531632812 | 1 | |
| 9.511005859 | 1 |
| Distinct | 32744 |
|---|---|
| Distinct (%) | 94.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.313003707 |
| Minimum | 0 |
|---|---|
| Maximum | 9.796392578 |
| Zeros | 1852 |
| Zeros (%) | 5.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3.27309198 |
| median | 4.239078125 |
| Q3 | 5.433044312 |
| 95-th percentile | 7.575033521 |
| Maximum | 9.796392578 |
| Range | 9.796392578 |
| Interquartile range (IQR) | 2.159952332 |
Descriptive statistics
| Standard deviation | 1.872006842 |
|---|---|
| Coefficient of variation (CV) | 0.4340378468 |
| Kurtosis | 0.4179649143 |
| Mean | 4.313003707 |
| Median Absolute Deviation (MAD) | 1.06927124 |
| Skewness | -0.05291426274 |
| Sum | 149411.0744 |
| Variance | 3.504409617 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1852 | 5.3% |
| 5.592882324 | 2 | < 0.1% |
| 5.296687988 | 2 | < 0.1% |
| 3.471577637 | 2 | < 0.1% |
| 4.941166016 | 2 | < 0.1% |
| 2.749988281 | 2 | < 0.1% |
| 4.451264648 | 2 | < 0.1% |
| 5.77767334 | 2 | < 0.1% |
| 4.334330078 | 2 | < 0.1% |
| 3.415598633 | 2 | < 0.1% |
| Other values (32734) | 32772 |
| Value | Count | Frequency (%) |
| 0 | 1852 | |
| 0.05376508331 | 1 | < 0.1% |
| 0.07805438232 | 1 | < 0.1% |
| 0.08096426392 | 1 | < 0.1% |
| 0.09130158997 | 1 | < 0.1% |
| 0.09224546051 | 1 | < 0.1% |
| 0.09587715149 | 1 | < 0.1% |
| 0.09827393341 | 1 | < 0.1% |
| 0.1156708603 | 1 | < 0.1% |
| 0.1662820892 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.796392578 | 1 | |
| 9.772299805 | 1 | |
| 9.752236328 | 1 | |
| 9.704908203 | 1 | |
| 9.693636719 | 1 | |
| 9.688960937 | 1 | |
| 9.687146484 | 1 | |
| 9.681642578 | 1 | |
| 9.631702148 | 1 | |
| 9.630237305 | 1 |
| Distinct | 33190 |
|---|---|
| Distinct (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.957059635 |
| Minimum | 0 |
|---|---|
| Maximum | 9.05496875 |
| Zeros | 1423 |
| Zeros (%) | 4.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.065869006 |
| Q1 | 1.85509314 |
| median | 2.79464502 |
| Q3 | 3.892645813 |
| 95-th percentile | 5.677727734 |
| Maximum | 9.05496875 |
| Range | 9.05496875 |
| Interquartile range (IQR) | 2.037552673 |
Descriptive statistics
| Standard deviation | 1.505042947 |
|---|---|
| Coefficient of variation (CV) | 0.5089660448 |
| Kurtosis | 0.2735678254 |
| Mean | 2.957059635 |
| Median Absolute Deviation (MAD) | 1.006006348 |
| Skewness | 0.4968710777 |
| Sum | 102438.4599 |
| Variance | 2.265154271 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1423 | 4.1% |
| 3.293982178 | 2 | < 0.1% |
| 4.298284668 | 2 | < 0.1% |
| 2.646483643 | 2 | < 0.1% |
| 3.242646973 | 2 | < 0.1% |
| 3.72209668 | 2 | < 0.1% |
| 2.280685059 | 2 | < 0.1% |
| 4.148039062 | 2 | < 0.1% |
| 4.998311523 | 2 | < 0.1% |
| 3.461662842 | 2 | < 0.1% |
| Other values (33180) | 33201 |
| Value | Count | Frequency (%) |
| 0 | 1423 | |
| 0.05777108002 | 1 | < 0.1% |
| 0.09741861725 | 1 | < 0.1% |
| 0.1004549103 | 1 | < 0.1% |
| 0.1027828751 | 1 | < 0.1% |
| 0.2021311493 | 1 | < 0.1% |
| 0.2034016724 | 1 | < 0.1% |
| 0.206105011 | 1 | < 0.1% |
| 0.2383424683 | 1 | < 0.1% |
| 0.2558401642 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.05496875 | 1 | |
| 9.051729492 | 1 | |
| 9.020098633 | 1 | |
| 8.966863281 | 1 | |
| 8.965724609 | 1 | |
| 8.935588867 | 1 | |
| 8.925925781 | 1 | |
| 8.923538086 | 1 | |
| 8.916717773 | 1 | |
| 8.907552734 | 1 |
| Distinct | 31602 |
|---|---|
| Distinct (%) | 91.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.124136391 |
| Minimum | 0 |
|---|---|
| Maximum | 10.34999805 |
| Zeros | 2994 |
| Zeros (%) | 8.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3.025755554 |
| median | 4.092966309 |
| Q3 | 5.409612915 |
| 95-th percentile | 7.428825659 |
| Maximum | 10.34999805 |
| Range | 10.34999805 |
| Interquartile range (IQR) | 2.383857361 |
Descriptive statistics
| Standard deviation | 2.003805326 |
|---|---|
| Coefficient of variation (CV) | 0.4858727104 |
| Kurtosis | 0.1152899216 |
| Mean | 4.124136391 |
| Median Absolute Deviation (MAD) | 1.162825073 |
| Skewness | -0.1276483446 |
| Sum | 142868.3329 |
| Variance | 4.015235785 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2994 | 8.6% |
| 5.301657227 | 2 | < 0.1% |
| 3.16152002 | 2 | < 0.1% |
| 3.731053711 | 2 | < 0.1% |
| 6.40251416 | 2 | < 0.1% |
| 3.392231689 | 2 | < 0.1% |
| 5.52630957 | 2 | < 0.1% |
| 4.406300781 | 2 | < 0.1% |
| 3.318557129 | 2 | < 0.1% |
| 5.344153809 | 2 | < 0.1% |
| Other values (31592) | 31630 |
| Value | Count | Frequency (%) |
| 0 | 2994 | |
| 0.05994290543 | 1 | < 0.1% |
| 0.06184532928 | 1 | < 0.1% |
| 0.06190799713 | 1 | < 0.1% |
| 0.06432749176 | 1 | < 0.1% |
| 0.06555576324 | 1 | < 0.1% |
| 0.06661433411 | 1 | < 0.1% |
| 0.06703911591 | 1 | < 0.1% |
| 0.06762007904 | 1 | < 0.1% |
| 0.0688780899 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10.34999805 | 1 | |
| 10.34407812 | 1 | |
| 10.27858984 | 1 | |
| 10.255 | 1 | |
| 10.23435547 | 1 | |
| 10.23135059 | 1 | |
| 10.22962793 | 1 | |
| 10.22626465 | 1 | |
| 10.21599316 | 1 | |
| 10.19888574 | 1 |
| Distinct | 30952 |
|---|---|
| Distinct (%) | 89.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.765702736 |
| Minimum | 0 |
|---|---|
| Maximum | 9.789501953 |
| Zeros | 3661 |
| Zeros (%) | 10.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.867401245 |
| median | 2.685934082 |
| Q3 | 3.701203064 |
| 95-th percentile | 5.471938501 |
| Maximum | 9.789501953 |
| Range | 9.789501953 |
| Interquartile range (IQR) | 1.833801819 |
Descriptive statistics
| Standard deviation | 1.538245296 |
|---|---|
| Coefficient of variation (CV) | 0.5561860557 |
| Kurtosis | 0.1504121083 |
| Mean | 2.765702736 |
| Median Absolute Deviation (MAD) | 0.9068327026 |
| Skewness | 0.2029748109 |
| Sum | 95809.47417 |
| Variance | 2.36619859 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3661 | 10.6% |
| 2.772634033 | 2 | < 0.1% |
| 2.281194824 | 2 | < 0.1% |
| 2.829662354 | 2 | < 0.1% |
| 4.096311035 | 2 | < 0.1% |
| 4.177881836 | 2 | < 0.1% |
| 2.742169189 | 2 | < 0.1% |
| 2.759802734 | 2 | < 0.1% |
| 3.449891846 | 2 | < 0.1% |
| 1.747108032 | 2 | < 0.1% |
| Other values (30942) | 30963 |
| Value | Count | Frequency (%) |
| 0 | 3661 | |
| 0.04327206802 | 1 | < 0.1% |
| 0.05373293304 | 1 | < 0.1% |
| 0.05482838821 | 1 | < 0.1% |
| 0.06091388702 | 1 | < 0.1% |
| 0.06123699951 | 1 | < 0.1% |
| 0.06150212479 | 1 | < 0.1% |
| 0.06163067245 | 1 | < 0.1% |
| 0.06341194916 | 1 | < 0.1% |
| 0.07005699921 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.789501953 | 1 | |
| 9.252208008 | 1 | |
| 9.14399707 | 1 | |
| 9.011677734 | 1 | |
| 8.835966797 | 1 | |
| 8.770001953 | 1 | |
| 8.691416016 | 1 | |
| 8.661050781 | 1 | |
| 8.598038086 | 1 | |
| 8.580469727 | 1 |
| Distinct | 33923 |
|---|---|
| Distinct (%) | 97.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.255119185 |
| Minimum | 0 |
|---|---|
| Maximum | 5.950260742 |
| Zeros | 583 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.298912415 |
| Q1 | 3.773064819 |
| median | 4.624716309 |
| Q3 | 4.97774353 |
| 95-th percentile | 5.340350879 |
| Maximum | 5.950260742 |
| Range | 5.950260742 |
| Interquartile range (IQR) | 1.204678711 |
Descriptive statistics
| Standard deviation | 1.078238006 |
|---|---|
| Coefficient of variation (CV) | 0.253397839 |
| Kurtosis | 2.970498944 |
| Mean | 4.255119185 |
| Median Absolute Deviation (MAD) | 0.4464968262 |
| Skewness | -1.640191977 |
| Sum | 147405.8388 |
| Variance | 1.162597198 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 583 | 1.7% |
| 4.606140137 | 3 | < 0.1% |
| 5.466534668 | 3 | < 0.1% |
| 4.490296875 | 2 | < 0.1% |
| 4.952848633 | 2 | < 0.1% |
| 4.369889648 | 2 | < 0.1% |
| 5.128876465 | 2 | < 0.1% |
| 4.894649902 | 2 | < 0.1% |
| 5.129799316 | 2 | < 0.1% |
| 4.534805176 | 2 | < 0.1% |
| Other values (33913) | 34039 |
| Value | Count | Frequency (%) |
| 0 | 583 | |
| 0.1014455566 | 1 | < 0.1% |
| 0.1230265045 | 1 | < 0.1% |
| 0.1231611099 | 1 | < 0.1% |
| 0.1247366791 | 1 | < 0.1% |
| 0.1315752258 | 1 | < 0.1% |
| 0.1416380005 | 1 | < 0.1% |
| 0.1680333862 | 1 | < 0.1% |
| 0.1932807007 | 1 | < 0.1% |
| 0.2625445862 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5.950260742 | 1 | |
| 5.945301758 | 1 | |
| 5.863141602 | 1 | |
| 5.83578125 | 1 | |
| 5.830320312 | 1 | |
| 5.820865234 | 1 | |
| 5.81526123 | 1 | |
| 5.802086914 | 1 | |
| 5.798219238 | 1 | |
| 5.795905762 | 1 |
| Distinct | 33737 |
|---|---|
| Distinct (%) | 97.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.453815486 |
| Minimum | 0 |
|---|---|
| Maximum | 11.04003125 |
| Zeros | 837 |
| Zeros (%) | 2.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 270.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.461707507 |
| Q1 | 4.00686853 |
| median | 7.072845947 |
| Q3 | 8.25281543 |
| 95-th percentile | 9.293142529 |
| Maximum | 11.04003125 |
| Range | 11.04003125 |
| Interquartile range (IQR) | 4.245946899 |
Descriptive statistics
| Standard deviation | 2.249975206 |
|---|---|
| Coefficient of variation (CV) | 0.3486271355 |
| Kurtosis | -0.251521506 |
| Mean | 6.453815486 |
| Median Absolute Deviation (MAD) | 1.552670654 |
| Skewness | -0.6645544155 |
| Sum | 223573.0761 |
| Variance | 5.062388427 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 837 | 2.4% |
| 9.08178418 | 2 | < 0.1% |
| 7.860595215 | 2 | < 0.1% |
| 8.340766602 | 2 | < 0.1% |
| 8.785417969 | 2 | < 0.1% |
| 9.214401367 | 2 | < 0.1% |
| 8.353989258 | 2 | < 0.1% |
| 9.533463867 | 2 | < 0.1% |
| 9.071806641 | 2 | < 0.1% |
| 8.405483398 | 2 | < 0.1% |
| Other values (33727) | 33787 |
| Value | Count | Frequency (%) |
| 0 | 837 | |
| 0.209085968 | 1 | < 0.1% |
| 0.2099752655 | 1 | < 0.1% |
| 0.2230535889 | 1 | < 0.1% |
| 0.2295393829 | 1 | < 0.1% |
| 0.2396819 | 1 | < 0.1% |
| 0.2518437042 | 1 | < 0.1% |
| 0.3175652466 | 1 | < 0.1% |
| 0.3961244507 | 1 | < 0.1% |
| 0.4883180847 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11.04003125 | 1 | |
| 10.71482617 | 1 | |
| 10.37858301 | 1 | |
| 10.35876563 | 1 | |
| 10.32136426 | 1 | |
| 10.31974121 | 1 | |
| 10.29013281 | 1 | |
| 10.27546387 | 1 | |
| 10.2563418 | 1 | |
| 10.25142578 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | Date & Time | AC 1 | AC 2 | AC 3 | AC 4 | AC 5 | AC 6 | AC 7 | AC 8 | AC 9 | AC 10 | AC 11 | AC 12 | AC 13 | AC 14 | AC 15 | AC 16 | AC 17 | AC 18 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 2019-08-01 00:00:00 | 7.518632 | 8.788315 | 0.000000 | 0.000000 | 2.617045 | 4.079041 | 2.782276 | 4.624447 | 5.222060 | 2.151238 | 1.585072 | 0.560373 | 3.142941 | 2.749470 | 5.417774 | 4.113460 | 3.305072 | 6.735981 |
| 1 | 2 | 2019-08-01 00:02:00 | 7.426114 | 8.940615 | 0.000000 | 0.000000 | 2.581625 | 3.781231 | 2.529366 | 5.057423 | 5.349465 | 2.414715 | 2.168184 | 1.818730 | 3.085110 | 2.720484 | 3.302422 | 3.986483 | 3.220588 | 6.379500 |
| 2 | 4 | 2019-08-01 00:04:00 | 7.052986 | 9.161103 | 0.000000 | 0.000000 | 2.592095 | 3.800127 | 2.332304 | 6.322521 | 3.995392 | 2.237114 | 3.345624 | 2.310409 | 3.132799 | 2.676861 | 3.539026 | 3.797881 | 3.131560 | 6.363475 |
| 3 | 6 | 2019-08-01 00:06:00 | 6.665446 | 9.065626 | 0.000000 | 0.000000 | 2.575639 | 3.772891 | 2.596200 | 5.805132 | 3.553778 | 1.878356 | 2.737645 | 2.510972 | 3.090007 | 2.666604 | 4.607439 | 3.062610 | 3.063953 | 6.127366 |
| 4 | 8 | 2019-08-01 00:08:00 | 6.674838 | 9.096130 | 0.000000 | 0.000000 | 2.021472 | 3.155697 | 2.845417 | 6.315060 | 3.042244 | 1.914650 | 2.452500 | 2.171791 | 3.097202 | 2.710572 | 5.332696 | 2.640150 | 2.864680 | 5.662474 |
| 5 | 10 | 2019-08-01 00:10:00 | 6.567156 | 9.037213 | 1.473477 | 0.284310 | 1.993010 | 3.910083 | 2.493377 | 5.169652 | 3.125476 | 1.900643 | 2.398804 | 2.503357 | 3.114851 | 2.774171 | 6.068003 | 2.497199 | 3.063759 | 5.805874 |
| 6 | 12 | 2019-08-01 00:12:00 | 6.453244 | 9.044919 | 1.829450 | 1.682536 | 1.887994 | 3.290534 | 2.384930 | 4.976252 | 3.097164 | 1.908729 | 2.302548 | 2.572876 | 3.102615 | 2.776231 | 6.450241 | 3.079120 | 3.089316 | 6.246021 |
| 7 | 14 | 2019-08-01 00:14:00 | 6.465478 | 9.090386 | 1.855697 | 2.259675 | 1.810324 | 3.510855 | 2.965181 | 4.956650 | 3.124932 | 2.183731 | 1.906641 | 2.391689 | 4.289458 | 3.495441 | 6.365123 | 3.017883 | 3.140137 | 6.273877 |
| 8 | 18 | 2019-08-01 00:18:00 | 6.368224 | 8.158823 | 2.839488 | 2.301862 | 2.811552 | 3.514442 | 3.300419 | 4.392541 | 3.096956 | 3.505346 | 1.885703 | 2.226469 | 4.367508 | 5.122032 | 6.328834 | 3.366155 | 3.501677 | 6.745517 |
| 9 | 20 | 2019-08-01 00:20:00 | 6.518812 | 7.962736 | 2.736410 | 1.887470 | 2.580264 | 3.852544 | 3.226622 | 4.614456 | 3.066071 | 3.430041 | 1.799723 | 2.431497 | 4.023512 | 5.179115 | 6.204670 | 3.280784 | 3.549387 | 7.077375 |
Last rows
| df_index | Date & Time | AC 1 | AC 2 | AC 3 | AC 4 | AC 5 | AC 6 | AC 7 | AC 8 | AC 9 | AC 10 | AC 11 | AC 12 | AC 13 | AC 14 | AC 15 | AC 16 | AC 17 | AC 18 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34632 | 87821 | 2019-09-30 23:41:00 | 2.894448 | 8.152282 | 4.154071 | 2.358552 | 1.157666 | 0.000000 | 3.032432 | 4.631509 | 4.894442 | 1.651598 | 5.041930 | 4.156700 | 4.419645 | 2.425940 | 3.670222 | 1.554395 | 3.450773 | 3.641647 |
| 34633 | 87823 | 2019-09-30 23:43:00 | 3.467300 | 8.335151 | 3.280842 | 2.104241 | 0.987955 | 0.000000 | 4.179667 | 3.595802 | 4.545187 | 1.463642 | 5.623581 | 4.516745 | 5.037816 | 2.304115 | 3.661031 | 1.597521 | 3.461860 | 3.650063 |
| 34634 | 87825 | 2019-09-30 23:45:00 | 2.883133 | 8.573294 | 2.976298 | 2.063815 | 0.000000 | 0.000000 | 4.614667 | 4.755458 | 4.201666 | 1.368366 | 6.108105 | 4.296801 | 5.008359 | 2.742367 | 3.704892 | 1.556722 | 2.675439 | 5.850771 |
| 34635 | 87827 | 2019-09-30 23:47:00 | 2.807148 | 8.482985 | 2.357741 | 1.764776 | 0.000000 | 0.000000 | 4.182721 | 4.997620 | 3.576860 | 1.378745 | 4.695837 | 3.892353 | 4.766902 | 2.973909 | 3.693686 | 1.578630 | 3.043333 | 7.149420 |
| 34636 | 87829 | 2019-09-30 23:49:00 | 0.000000 | 6.657014 | 2.418670 | 1.531352 | 0.000000 | 0.000000 | 4.014735 | 4.820883 | 3.558004 | 2.819254 | 4.595729 | 3.531902 | 5.267506 | 2.840872 | 3.719538 | 1.503313 | 3.032459 | 7.171342 |
| 34637 | 87831 | 2019-09-30 23:51:00 | 0.000000 | 6.089533 | 2.322677 | 1.422932 | 0.000000 | 0.000000 | 3.729901 | 3.747301 | 3.578350 | 1.714157 | 5.146438 | 3.253012 | 2.464426 | 2.829701 | 3.693877 | 1.992432 | 3.029462 | 7.202612 |
| 34638 | 87833 | 2019-09-30 23:53:00 | 0.000000 | 6.046765 | 2.195754 | 1.861175 | 0.813454 | 0.000000 | 3.666080 | 3.017628 | 3.600397 | 1.547953 | 4.379771 | 3.144666 | 3.045807 | 2.693068 | 4.090679 | 1.944854 | 3.048858 | 7.348333 |
| 34639 | 87835 | 2019-09-30 23:55:00 | 0.000000 | 6.122385 | 2.192198 | 2.083315 | 1.046250 | 0.000000 | 3.668421 | 3.006311 | 3.614301 | 1.860847 | 5.019769 | 3.154221 | 3.648026 | 2.439526 | 4.062719 | 1.854352 | 3.027539 | 7.259989 |
| 34640 | 87837 | 2019-09-30 23:57:00 | 1.209176 | 6.152532 | 2.211421 | 0.000000 | 1.448103 | 0.000000 | 3.151248 | 2.871690 | 3.417942 | 2.185493 | 5.174168 | 2.772349 | 3.786657 | 2.060023 | 4.057525 | 1.870886 | 2.991946 | 7.134647 |
| 34641 | 87839 | 2019-09-30 23:59:00 | 1.430442 | 6.078281 | 1.891162 | 0.000000 | 1.577491 | 4.364239 | 3.126339 | 3.287224 | 3.986978 | 2.013912 | 4.821829 | 3.363855 | 3.380110 | 1.949240 | 4.026304 | 1.862166 | 3.009434 | 7.179719 |